package com.ygqh.baby.po;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WdtQybStockOutExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WdtQybStockOutExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStockoutIdIsNull() {
            addCriterion("stockout_id is null");
            return (Criteria) this;
        }

        public Criteria andStockoutIdIsNotNull() {
            addCriterion("stockout_id is not null");
            return (Criteria) this;
        }

        public Criteria andStockoutIdEqualTo(Integer value) {
            addCriterion("stockout_id =", value, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdNotEqualTo(Integer value) {
            addCriterion("stockout_id <>", value, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdGreaterThan(Integer value) {
            addCriterion("stockout_id >", value, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("stockout_id >=", value, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdLessThan(Integer value) {
            addCriterion("stockout_id <", value, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdLessThanOrEqualTo(Integer value) {
            addCriterion("stockout_id <=", value, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdIn(List<Integer> values) {
            addCriterion("stockout_id in", values, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdNotIn(List<Integer> values) {
            addCriterion("stockout_id not in", values, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdBetween(Integer value1, Integer value2) {
            addCriterion("stockout_id between", value1, value2, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andStockoutIdNotBetween(Integer value1, Integer value2) {
            addCriterion("stockout_id not between", value1, value2, "stockoutId");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNull() {
            addCriterion("warehouse_no is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNotNull() {
            addCriterion("warehouse_no is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoEqualTo(String value) {
            addCriterion("warehouse_no =", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotEqualTo(String value) {
            addCriterion("warehouse_no <>", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThan(String value) {
            addCriterion("warehouse_no >", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThanOrEqualTo(String value) {
            addCriterion("warehouse_no >=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThan(String value) {
            addCriterion("warehouse_no <", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThanOrEqualTo(String value) {
            addCriterion("warehouse_no <=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLike(String value) {
            addCriterion("warehouse_no like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotLike(String value) {
            addCriterion("warehouse_no not like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIn(List<String> values) {
            addCriterion("warehouse_no in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotIn(List<String> values) {
            addCriterion("warehouse_no not in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoBetween(String value1, String value2) {
            addCriterion("warehouse_no between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotBetween(String value1, String value2) {
            addCriterion("warehouse_no not between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andConsignTimeIsNull() {
            addCriterion("consign_time is null");
            return (Criteria) this;
        }

        public Criteria andConsignTimeIsNotNull() {
            addCriterion("consign_time is not null");
            return (Criteria) this;
        }

        public Criteria andConsignTimeEqualTo(Date value) {
            addCriterion("consign_time =", value, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeNotEqualTo(Date value) {
            addCriterion("consign_time <>", value, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeGreaterThan(Date value) {
            addCriterion("consign_time >", value, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("consign_time >=", value, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeLessThan(Date value) {
            addCriterion("consign_time <", value, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeLessThanOrEqualTo(Date value) {
            addCriterion("consign_time <=", value, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeIn(List<Date> values) {
            addCriterion("consign_time in", values, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeNotIn(List<Date> values) {
            addCriterion("consign_time not in", values, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeBetween(Date value1, Date value2) {
            addCriterion("consign_time between", value1, value2, "consignTime");
            return (Criteria) this;
        }

        public Criteria andConsignTimeNotBetween(Date value1, Date value2) {
            addCriterion("consign_time not between", value1, value2, "consignTime");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(Integer value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(Integer value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(Integer value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(Integer value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(Integer value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<Integer> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<Integer> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(Integer value1, Integer value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameIsNull() {
            addCriterion("order_type_name is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameIsNotNull() {
            addCriterion("order_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameEqualTo(String value) {
            addCriterion("order_type_name =", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameNotEqualTo(String value) {
            addCriterion("order_type_name <>", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameGreaterThan(String value) {
            addCriterion("order_type_name >", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("order_type_name >=", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameLessThan(String value) {
            addCriterion("order_type_name <", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameLessThanOrEqualTo(String value) {
            addCriterion("order_type_name <=", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameLike(String value) {
            addCriterion("order_type_name like", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameNotLike(String value) {
            addCriterion("order_type_name not like", value, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameIn(List<String> values) {
            addCriterion("order_type_name in", values, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameNotIn(List<String> values) {
            addCriterion("order_type_name not in", values, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameBetween(String value1, String value2) {
            addCriterion("order_type_name between", value1, value2, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNameNotBetween(String value1, String value2) {
            addCriterion("order_type_name not between", value1, value2, "orderTypeName");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIsNull() {
            addCriterion("trade_type is null");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIsNotNull() {
            addCriterion("trade_type is not null");
            return (Criteria) this;
        }

        public Criteria andTradeTypeEqualTo(Integer value) {
            addCriterion("trade_type =", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotEqualTo(Integer value) {
            addCriterion("trade_type <>", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeGreaterThan(Integer value) {
            addCriterion("trade_type >", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("trade_type >=", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLessThan(Integer value) {
            addCriterion("trade_type <", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLessThanOrEqualTo(Integer value) {
            addCriterion("trade_type <=", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIn(List<Integer> values) {
            addCriterion("trade_type in", values, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotIn(List<Integer> values) {
            addCriterion("trade_type not in", values, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeBetween(Integer value1, Integer value2) {
            addCriterion("trade_type between", value1, value2, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("trade_type not between", value1, value2, "tradeType");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIsNull() {
            addCriterion("goods_count is null");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIsNotNull() {
            addCriterion("goods_count is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsCountEqualTo(BigDecimal value) {
            addCriterion("goods_count =", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotEqualTo(BigDecimal value) {
            addCriterion("goods_count <>", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountGreaterThan(BigDecimal value) {
            addCriterion("goods_count >", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_count >=", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountLessThan(BigDecimal value) {
            addCriterion("goods_count <", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_count <=", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIn(List<BigDecimal> values) {
            addCriterion("goods_count in", values, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotIn(List<BigDecimal> values) {
            addCriterion("goods_count not in", values, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_count between", value1, value2, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_count not between", value1, value2, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountIsNull() {
            addCriterion("goods_total_amount is null");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountIsNotNull() {
            addCriterion("goods_total_amount is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountEqualTo(BigDecimal value) {
            addCriterion("goods_total_amount =", value, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountNotEqualTo(BigDecimal value) {
            addCriterion("goods_total_amount <>", value, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountGreaterThan(BigDecimal value) {
            addCriterion("goods_total_amount >", value, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_total_amount >=", value, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountLessThan(BigDecimal value) {
            addCriterion("goods_total_amount <", value, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_total_amount <=", value, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountIn(List<BigDecimal> values) {
            addCriterion("goods_total_amount in", values, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountNotIn(List<BigDecimal> values) {
            addCriterion("goods_total_amount not in", values, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_total_amount between", value1, value2, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_total_amount not between", value1, value2, "goodsTotalAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostIsNull() {
            addCriterion("goods_total_cost is null");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostIsNotNull() {
            addCriterion("goods_total_cost is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostEqualTo(BigDecimal value) {
            addCriterion("goods_total_cost =", value, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostNotEqualTo(BigDecimal value) {
            addCriterion("goods_total_cost <>", value, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostGreaterThan(BigDecimal value) {
            addCriterion("goods_total_cost >", value, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_total_cost >=", value, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostLessThan(BigDecimal value) {
            addCriterion("goods_total_cost <", value, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_total_cost <=", value, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostIn(List<BigDecimal> values) {
            addCriterion("goods_total_cost in", values, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostNotIn(List<BigDecimal> values) {
            addCriterion("goods_total_cost not in", values, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_total_cost between", value1, value2, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalCostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_total_cost not between", value1, value2, "goodsTotalCost");
            return (Criteria) this;
        }

        public Criteria andPostFeeIsNull() {
            addCriterion("post_fee is null");
            return (Criteria) this;
        }

        public Criteria andPostFeeIsNotNull() {
            addCriterion("post_fee is not null");
            return (Criteria) this;
        }

        public Criteria andPostFeeEqualTo(BigDecimal value) {
            addCriterion("post_fee =", value, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeNotEqualTo(BigDecimal value) {
            addCriterion("post_fee <>", value, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeGreaterThan(BigDecimal value) {
            addCriterion("post_fee >", value, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("post_fee >=", value, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeLessThan(BigDecimal value) {
            addCriterion("post_fee <", value, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("post_fee <=", value, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeIn(List<BigDecimal> values) {
            addCriterion("post_fee in", values, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeNotIn(List<BigDecimal> values) {
            addCriterion("post_fee not in", values, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("post_fee between", value1, value2, "postFee");
            return (Criteria) this;
        }

        public Criteria andPostFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("post_fee not between", value1, value2, "postFee");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoIsNull() {
            addCriterion("logistics_no is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoIsNotNull() {
            addCriterion("logistics_no is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoEqualTo(String value) {
            addCriterion("logistics_no =", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotEqualTo(String value) {
            addCriterion("logistics_no <>", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoGreaterThan(String value) {
            addCriterion("logistics_no >", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_no >=", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoLessThan(String value) {
            addCriterion("logistics_no <", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoLessThanOrEqualTo(String value) {
            addCriterion("logistics_no <=", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoLike(String value) {
            addCriterion("logistics_no like", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotLike(String value) {
            addCriterion("logistics_no not like", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoIn(List<String> values) {
            addCriterion("logistics_no in", values, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotIn(List<String> values) {
            addCriterion("logistics_no not in", values, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoBetween(String value1, String value2) {
            addCriterion("logistics_no between", value1, value2, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotBetween(String value1, String value2) {
            addCriterion("logistics_no not between", value1, value2, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andPackageFeeIsNull() {
            addCriterion("package_fee is null");
            return (Criteria) this;
        }

        public Criteria andPackageFeeIsNotNull() {
            addCriterion("package_fee is not null");
            return (Criteria) this;
        }

        public Criteria andPackageFeeEqualTo(BigDecimal value) {
            addCriterion("package_fee =", value, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeNotEqualTo(BigDecimal value) {
            addCriterion("package_fee <>", value, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeGreaterThan(BigDecimal value) {
            addCriterion("package_fee >", value, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("package_fee >=", value, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeLessThan(BigDecimal value) {
            addCriterion("package_fee <", value, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("package_fee <=", value, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeIn(List<BigDecimal> values) {
            addCriterion("package_fee in", values, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeNotIn(List<BigDecimal> values) {
            addCriterion("package_fee not in", values, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("package_fee between", value1, value2, "packageFee");
            return (Criteria) this;
        }

        public Criteria andPackageFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("package_fee not between", value1, value2, "packageFee");
            return (Criteria) this;
        }

        public Criteria andReceiverNameIsNull() {
            addCriterion("receiver_name is null");
            return (Criteria) this;
        }

        public Criteria andReceiverNameIsNotNull() {
            addCriterion("receiver_name is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverNameEqualTo(String value) {
            addCriterion("receiver_name =", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotEqualTo(String value) {
            addCriterion("receiver_name <>", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameGreaterThan(String value) {
            addCriterion("receiver_name >", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_name >=", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameLessThan(String value) {
            addCriterion("receiver_name <", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameLessThanOrEqualTo(String value) {
            addCriterion("receiver_name <=", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameLike(String value) {
            addCriterion("receiver_name like", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotLike(String value) {
            addCriterion("receiver_name not like", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameIn(List<String> values) {
            addCriterion("receiver_name in", values, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotIn(List<String> values) {
            addCriterion("receiver_name not in", values, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameBetween(String value1, String value2) {
            addCriterion("receiver_name between", value1, value2, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotBetween(String value1, String value2) {
            addCriterion("receiver_name not between", value1, value2, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryIsNull() {
            addCriterion("receiver_country is null");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryIsNotNull() {
            addCriterion("receiver_country is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryEqualTo(String value) {
            addCriterion("receiver_country =", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryNotEqualTo(String value) {
            addCriterion("receiver_country <>", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryGreaterThan(String value) {
            addCriterion("receiver_country >", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_country >=", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryLessThan(String value) {
            addCriterion("receiver_country <", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryLessThanOrEqualTo(String value) {
            addCriterion("receiver_country <=", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryLike(String value) {
            addCriterion("receiver_country like", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryNotLike(String value) {
            addCriterion("receiver_country not like", value, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryIn(List<String> values) {
            addCriterion("receiver_country in", values, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryNotIn(List<String> values) {
            addCriterion("receiver_country not in", values, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryBetween(String value1, String value2) {
            addCriterion("receiver_country between", value1, value2, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverCountryNotBetween(String value1, String value2) {
            addCriterion("receiver_country not between", value1, value2, "receiverCountry");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceIsNull() {
            addCriterion("receiver_province is null");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceIsNotNull() {
            addCriterion("receiver_province is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceEqualTo(String value) {
            addCriterion("receiver_province =", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotEqualTo(String value) {
            addCriterion("receiver_province <>", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceGreaterThan(String value) {
            addCriterion("receiver_province >", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_province >=", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceLessThan(String value) {
            addCriterion("receiver_province <", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceLessThanOrEqualTo(String value) {
            addCriterion("receiver_province <=", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceLike(String value) {
            addCriterion("receiver_province like", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotLike(String value) {
            addCriterion("receiver_province not like", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceIn(List<String> values) {
            addCriterion("receiver_province in", values, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotIn(List<String> values) {
            addCriterion("receiver_province not in", values, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceBetween(String value1, String value2) {
            addCriterion("receiver_province between", value1, value2, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotBetween(String value1, String value2) {
            addCriterion("receiver_province not between", value1, value2, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverCityIsNull() {
            addCriterion("receiver_city is null");
            return (Criteria) this;
        }

        public Criteria andReceiverCityIsNotNull() {
            addCriterion("receiver_city is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverCityEqualTo(String value) {
            addCriterion("receiver_city =", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotEqualTo(String value) {
            addCriterion("receiver_city <>", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityGreaterThan(String value) {
            addCriterion("receiver_city >", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_city >=", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityLessThan(String value) {
            addCriterion("receiver_city <", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityLessThanOrEqualTo(String value) {
            addCriterion("receiver_city <=", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityLike(String value) {
            addCriterion("receiver_city like", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotLike(String value) {
            addCriterion("receiver_city not like", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityIn(List<String> values) {
            addCriterion("receiver_city in", values, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotIn(List<String> values) {
            addCriterion("receiver_city not in", values, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityBetween(String value1, String value2) {
            addCriterion("receiver_city between", value1, value2, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotBetween(String value1, String value2) {
            addCriterion("receiver_city not between", value1, value2, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictIsNull() {
            addCriterion("receiver_district is null");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictIsNotNull() {
            addCriterion("receiver_district is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictEqualTo(String value) {
            addCriterion("receiver_district =", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotEqualTo(String value) {
            addCriterion("receiver_district <>", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictGreaterThan(String value) {
            addCriterion("receiver_district >", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_district >=", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictLessThan(String value) {
            addCriterion("receiver_district <", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictLessThanOrEqualTo(String value) {
            addCriterion("receiver_district <=", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictLike(String value) {
            addCriterion("receiver_district like", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotLike(String value) {
            addCriterion("receiver_district not like", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictIn(List<String> values) {
            addCriterion("receiver_district in", values, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotIn(List<String> values) {
            addCriterion("receiver_district not in", values, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictBetween(String value1, String value2) {
            addCriterion("receiver_district between", value1, value2, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotBetween(String value1, String value2) {
            addCriterion("receiver_district not between", value1, value2, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeIsNull() {
            addCriterion("receiver_province_code is null");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeIsNotNull() {
            addCriterion("receiver_province_code is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeEqualTo(String value) {
            addCriterion("receiver_province_code =", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeNotEqualTo(String value) {
            addCriterion("receiver_province_code <>", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeGreaterThan(String value) {
            addCriterion("receiver_province_code >", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_province_code >=", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeLessThan(String value) {
            addCriterion("receiver_province_code <", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeLessThanOrEqualTo(String value) {
            addCriterion("receiver_province_code <=", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeLike(String value) {
            addCriterion("receiver_province_code like", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeNotLike(String value) {
            addCriterion("receiver_province_code not like", value, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeIn(List<String> values) {
            addCriterion("receiver_province_code in", values, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeNotIn(List<String> values) {
            addCriterion("receiver_province_code not in", values, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeBetween(String value1, String value2) {
            addCriterion("receiver_province_code between", value1, value2, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceCodeNotBetween(String value1, String value2) {
            addCriterion("receiver_province_code not between", value1, value2, "receiverProvinceCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeIsNull() {
            addCriterion("receiver_city_code is null");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeIsNotNull() {
            addCriterion("receiver_city_code is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeEqualTo(String value) {
            addCriterion("receiver_city_code =", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeNotEqualTo(String value) {
            addCriterion("receiver_city_code <>", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeGreaterThan(String value) {
            addCriterion("receiver_city_code >", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_city_code >=", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeLessThan(String value) {
            addCriterion("receiver_city_code <", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeLessThanOrEqualTo(String value) {
            addCriterion("receiver_city_code <=", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeLike(String value) {
            addCriterion("receiver_city_code like", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeNotLike(String value) {
            addCriterion("receiver_city_code not like", value, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeIn(List<String> values) {
            addCriterion("receiver_city_code in", values, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeNotIn(List<String> values) {
            addCriterion("receiver_city_code not in", values, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeBetween(String value1, String value2) {
            addCriterion("receiver_city_code between", value1, value2, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverCityCodeNotBetween(String value1, String value2) {
            addCriterion("receiver_city_code not between", value1, value2, "receiverCityCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeIsNull() {
            addCriterion("receiver_district_code is null");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeIsNotNull() {
            addCriterion("receiver_district_code is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeEqualTo(String value) {
            addCriterion("receiver_district_code =", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeNotEqualTo(String value) {
            addCriterion("receiver_district_code <>", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeGreaterThan(String value) {
            addCriterion("receiver_district_code >", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_district_code >=", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeLessThan(String value) {
            addCriterion("receiver_district_code <", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeLessThanOrEqualTo(String value) {
            addCriterion("receiver_district_code <=", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeLike(String value) {
            addCriterion("receiver_district_code like", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeNotLike(String value) {
            addCriterion("receiver_district_code not like", value, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeIn(List<String> values) {
            addCriterion("receiver_district_code in", values, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeNotIn(List<String> values) {
            addCriterion("receiver_district_code not in", values, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeBetween(String value1, String value2) {
            addCriterion("receiver_district_code between", value1, value2, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictCodeNotBetween(String value1, String value2) {
            addCriterion("receiver_district_code not between", value1, value2, "receiverDistrictCode");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressIsNull() {
            addCriterion("receiver_address is null");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressIsNotNull() {
            addCriterion("receiver_address is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressEqualTo(String value) {
            addCriterion("receiver_address =", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotEqualTo(String value) {
            addCriterion("receiver_address <>", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressGreaterThan(String value) {
            addCriterion("receiver_address >", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_address >=", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressLessThan(String value) {
            addCriterion("receiver_address <", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressLessThanOrEqualTo(String value) {
            addCriterion("receiver_address <=", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressLike(String value) {
            addCriterion("receiver_address like", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotLike(String value) {
            addCriterion("receiver_address not like", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressIn(List<String> values) {
            addCriterion("receiver_address in", values, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotIn(List<String> values) {
            addCriterion("receiver_address not in", values, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressBetween(String value1, String value2) {
            addCriterion("receiver_address between", value1, value2, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotBetween(String value1, String value2) {
            addCriterion("receiver_address not between", value1, value2, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileIsNull() {
            addCriterion("receiver_mobile is null");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileIsNotNull() {
            addCriterion("receiver_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileEqualTo(String value) {
            addCriterion("receiver_mobile =", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotEqualTo(String value) {
            addCriterion("receiver_mobile <>", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileGreaterThan(String value) {
            addCriterion("receiver_mobile >", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_mobile >=", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileLessThan(String value) {
            addCriterion("receiver_mobile <", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileLessThanOrEqualTo(String value) {
            addCriterion("receiver_mobile <=", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileLike(String value) {
            addCriterion("receiver_mobile like", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotLike(String value) {
            addCriterion("receiver_mobile not like", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileIn(List<String> values) {
            addCriterion("receiver_mobile in", values, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotIn(List<String> values) {
            addCriterion("receiver_mobile not in", values, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileBetween(String value1, String value2) {
            addCriterion("receiver_mobile between", value1, value2, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotBetween(String value1, String value2) {
            addCriterion("receiver_mobile not between", value1, value2, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoIsNull() {
            addCriterion("receiver_telno is null");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoIsNotNull() {
            addCriterion("receiver_telno is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoEqualTo(String value) {
            addCriterion("receiver_telno =", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotEqualTo(String value) {
            addCriterion("receiver_telno <>", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoGreaterThan(String value) {
            addCriterion("receiver_telno >", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_telno >=", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoLessThan(String value) {
            addCriterion("receiver_telno <", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoLessThanOrEqualTo(String value) {
            addCriterion("receiver_telno <=", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoLike(String value) {
            addCriterion("receiver_telno like", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotLike(String value) {
            addCriterion("receiver_telno not like", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoIn(List<String> values) {
            addCriterion("receiver_telno in", values, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotIn(List<String> values) {
            addCriterion("receiver_telno not in", values, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoBetween(String value1, String value2) {
            addCriterion("receiver_telno between", value1, value2, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotBetween(String value1, String value2) {
            addCriterion("receiver_telno not between", value1, value2, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverZipIsNull() {
            addCriterion("receiver_zip is null");
            return (Criteria) this;
        }

        public Criteria andReceiverZipIsNotNull() {
            addCriterion("receiver_zip is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverZipEqualTo(String value) {
            addCriterion("receiver_zip =", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotEqualTo(String value) {
            addCriterion("receiver_zip <>", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipGreaterThan(String value) {
            addCriterion("receiver_zip >", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_zip >=", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipLessThan(String value) {
            addCriterion("receiver_zip <", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipLessThanOrEqualTo(String value) {
            addCriterion("receiver_zip <=", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipLike(String value) {
            addCriterion("receiver_zip like", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotLike(String value) {
            addCriterion("receiver_zip not like", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipIn(List<String> values) {
            addCriterion("receiver_zip in", values, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotIn(List<String> values) {
            addCriterion("receiver_zip not in", values, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipBetween(String value1, String value2) {
            addCriterion("receiver_zip between", value1, value2, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotBetween(String value1, String value2) {
            addCriterion("receiver_zip not between", value1, value2, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbIsNull() {
            addCriterion("receiver_dtb is null");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbIsNotNull() {
            addCriterion("receiver_dtb is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbEqualTo(String value) {
            addCriterion("receiver_dtb =", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotEqualTo(String value) {
            addCriterion("receiver_dtb <>", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbGreaterThan(String value) {
            addCriterion("receiver_dtb >", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_dtb >=", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbLessThan(String value) {
            addCriterion("receiver_dtb <", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbLessThanOrEqualTo(String value) {
            addCriterion("receiver_dtb <=", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbLike(String value) {
            addCriterion("receiver_dtb like", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotLike(String value) {
            addCriterion("receiver_dtb not like", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbIn(List<String> values) {
            addCriterion("receiver_dtb in", values, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotIn(List<String> values) {
            addCriterion("receiver_dtb not in", values, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbBetween(String value1, String value2) {
            addCriterion("receiver_dtb between", value1, value2, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotBetween(String value1, String value2) {
            addCriterion("receiver_dtb not between", value1, value2, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(BigDecimal value) {
            addCriterion("weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(BigDecimal value) {
            addCriterion("weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(BigDecimal value) {
            addCriterion("weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(BigDecimal value) {
            addCriterion("weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<BigDecimal> values) {
            addCriterion("weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<BigDecimal> values) {
            addCriterion("weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIsNull() {
            addCriterion("logistics_type is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIsNotNull() {
            addCriterion("logistics_type is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeEqualTo(Integer value) {
            addCriterion("logistics_type =", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotEqualTo(Integer value) {
            addCriterion("logistics_type <>", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeGreaterThan(Integer value) {
            addCriterion("logistics_type >", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("logistics_type >=", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeLessThan(Integer value) {
            addCriterion("logistics_type <", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("logistics_type <=", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIn(List<Integer> values) {
            addCriterion("logistics_type in", values, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotIn(List<Integer> values) {
            addCriterion("logistics_type not in", values, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeBetween(Integer value1, Integer value2) {
            addCriterion("logistics_type between", value1, value2, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("logistics_type not between", value1, value2, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeIsNull() {
            addCriterion("logistics_code is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeIsNotNull() {
            addCriterion("logistics_code is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeEqualTo(String value) {
            addCriterion("logistics_code =", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotEqualTo(String value) {
            addCriterion("logistics_code <>", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeGreaterThan(String value) {
            addCriterion("logistics_code >", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_code >=", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeLessThan(String value) {
            addCriterion("logistics_code <", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeLessThanOrEqualTo(String value) {
            addCriterion("logistics_code <=", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeLike(String value) {
            addCriterion("logistics_code like", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotLike(String value) {
            addCriterion("logistics_code not like", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeIn(List<String> values) {
            addCriterion("logistics_code in", values, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotIn(List<String> values) {
            addCriterion("logistics_code not in", values, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeBetween(String value1, String value2) {
            addCriterion("logistics_code between", value1, value2, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotBetween(String value1, String value2) {
            addCriterion("logistics_code not between", value1, value2, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameIsNull() {
            addCriterion("logistics_name is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameIsNotNull() {
            addCriterion("logistics_name is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameEqualTo(String value) {
            addCriterion("logistics_name =", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotEqualTo(String value) {
            addCriterion("logistics_name <>", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameGreaterThan(String value) {
            addCriterion("logistics_name >", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_name >=", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameLessThan(String value) {
            addCriterion("logistics_name <", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameLessThanOrEqualTo(String value) {
            addCriterion("logistics_name <=", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameLike(String value) {
            addCriterion("logistics_name like", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotLike(String value) {
            addCriterion("logistics_name not like", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameIn(List<String> values) {
            addCriterion("logistics_name in", values, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotIn(List<String> values) {
            addCriterion("logistics_name not in", values, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameBetween(String value1, String value2) {
            addCriterion("logistics_name between", value1, value2, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotBetween(String value1, String value2) {
            addCriterion("logistics_name not between", value1, value2, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkIsNull() {
            addCriterion("print_remark is null");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkIsNotNull() {
            addCriterion("print_remark is not null");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkEqualTo(String value) {
            addCriterion("print_remark =", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotEqualTo(String value) {
            addCriterion("print_remark <>", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkGreaterThan(String value) {
            addCriterion("print_remark >", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("print_remark >=", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkLessThan(String value) {
            addCriterion("print_remark <", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkLessThanOrEqualTo(String value) {
            addCriterion("print_remark <=", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkLike(String value) {
            addCriterion("print_remark like", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotLike(String value) {
            addCriterion("print_remark not like", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkIn(List<String> values) {
            addCriterion("print_remark in", values, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotIn(List<String> values) {
            addCriterion("print_remark not in", values, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkBetween(String value1, String value2) {
            addCriterion("print_remark between", value1, value2, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotBetween(String value1, String value2) {
            addCriterion("print_remark not between", value1, value2, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPaidIsNull() {
            addCriterion("paid is null");
            return (Criteria) this;
        }

        public Criteria andPaidIsNotNull() {
            addCriterion("paid is not null");
            return (Criteria) this;
        }

        public Criteria andPaidEqualTo(BigDecimal value) {
            addCriterion("paid =", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotEqualTo(BigDecimal value) {
            addCriterion("paid <>", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidGreaterThan(BigDecimal value) {
            addCriterion("paid >", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paid >=", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidLessThan(BigDecimal value) {
            addCriterion("paid <", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paid <=", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidIn(List<BigDecimal> values) {
            addCriterion("paid in", values, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotIn(List<BigDecimal> values) {
            addCriterion("paid not in", values, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid between", value1, value2, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid not between", value1, value2, "paid");
            return (Criteria) this;
        }

        public Criteria andCreatedIsNull() {
            addCriterion("created is null");
            return (Criteria) this;
        }

        public Criteria andCreatedIsNotNull() {
            addCriterion("created is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedEqualTo(Date value) {
            addCriterion("created =", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotEqualTo(Date value) {
            addCriterion("created <>", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedGreaterThan(Date value) {
            addCriterion("created >", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedGreaterThanOrEqualTo(Date value) {
            addCriterion("created >=", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedLessThan(Date value) {
            addCriterion("created <", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedLessThanOrEqualTo(Date value) {
            addCriterion("created <=", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedIn(List<Date> values) {
            addCriterion("created in", values, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotIn(List<Date> values) {
            addCriterion("created not in", values, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedBetween(Date value1, Date value2) {
            addCriterion("created between", value1, value2, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotBetween(Date value1, Date value2) {
            addCriterion("created not between", value1, value2, "created");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNull() {
            addCriterion("trade_no is null");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNotNull() {
            addCriterion("trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNoEqualTo(String value) {
            addCriterion("trade_no =", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotEqualTo(String value) {
            addCriterion("trade_no <>", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThan(String value) {
            addCriterion("trade_no >", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("trade_no >=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThan(String value) {
            addCriterion("trade_no <", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThanOrEqualTo(String value) {
            addCriterion("trade_no <=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLike(String value) {
            addCriterion("trade_no like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotLike(String value) {
            addCriterion("trade_no not like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIn(List<String> values) {
            addCriterion("trade_no in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotIn(List<String> values) {
            addCriterion("trade_no not in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoBetween(String value1, String value2) {
            addCriterion("trade_no between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotBetween(String value1, String value2) {
            addCriterion("trade_no not between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoIsNull() {
            addCriterion("src_trade_no is null");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoIsNotNull() {
            addCriterion("src_trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoEqualTo(String value) {
            addCriterion("src_trade_no =", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoNotEqualTo(String value) {
            addCriterion("src_trade_no <>", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoGreaterThan(String value) {
            addCriterion("src_trade_no >", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("src_trade_no >=", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoLessThan(String value) {
            addCriterion("src_trade_no <", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoLessThanOrEqualTo(String value) {
            addCriterion("src_trade_no <=", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoLike(String value) {
            addCriterion("src_trade_no like", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoNotLike(String value) {
            addCriterion("src_trade_no not like", value, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoIn(List<String> values) {
            addCriterion("src_trade_no in", values, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoNotIn(List<String> values) {
            addCriterion("src_trade_no not in", values, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoBetween(String value1, String value2) {
            addCriterion("src_trade_no between", value1, value2, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andSrcTradeNoNotBetween(String value1, String value2) {
            addCriterion("src_trade_no not between", value1, value2, "srcTradeNo");
            return (Criteria) this;
        }

        public Criteria andNickNameIsNull() {
            addCriterion("nick_name is null");
            return (Criteria) this;
        }

        public Criteria andNickNameIsNotNull() {
            addCriterion("nick_name is not null");
            return (Criteria) this;
        }

        public Criteria andNickNameEqualTo(String value) {
            addCriterion("nick_name =", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotEqualTo(String value) {
            addCriterion("nick_name <>", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameGreaterThan(String value) {
            addCriterion("nick_name >", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameGreaterThanOrEqualTo(String value) {
            addCriterion("nick_name >=", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameLessThan(String value) {
            addCriterion("nick_name <", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameLessThanOrEqualTo(String value) {
            addCriterion("nick_name <=", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameLike(String value) {
            addCriterion("nick_name like", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotLike(String value) {
            addCriterion("nick_name not like", value, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameIn(List<String> values) {
            addCriterion("nick_name in", values, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotIn(List<String> values) {
            addCriterion("nick_name not in", values, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameBetween(String value1, String value2) {
            addCriterion("nick_name between", value1, value2, "nickName");
            return (Criteria) this;
        }

        public Criteria andNickNameNotBetween(String value1, String value2) {
            addCriterion("nick_name not between", value1, value2, "nickName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIsNull() {
            addCriterion("customer_no is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIsNotNull() {
            addCriterion("customer_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNoEqualTo(String value) {
            addCriterion("customer_no =", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotEqualTo(String value) {
            addCriterion("customer_no <>", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoGreaterThan(String value) {
            addCriterion("customer_no >", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoGreaterThanOrEqualTo(String value) {
            addCriterion("customer_no >=", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLessThan(String value) {
            addCriterion("customer_no <", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLessThanOrEqualTo(String value) {
            addCriterion("customer_no <=", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLike(String value) {
            addCriterion("customer_no like", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotLike(String value) {
            addCriterion("customer_no not like", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIn(List<String> values) {
            addCriterion("customer_no in", values, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotIn(List<String> values) {
            addCriterion("customer_no not in", values, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoBetween(String value1, String value2) {
            addCriterion("customer_no between", value1, value2, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotBetween(String value1, String value2) {
            addCriterion("customer_no not between", value1, value2, "customerNo");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIsNull() {
            addCriterion("trade_time is null");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIsNotNull() {
            addCriterion("trade_time is not null");
            return (Criteria) this;
        }

        public Criteria andTradeTimeEqualTo(Date value) {
            addCriterion("trade_time =", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotEqualTo(Date value) {
            addCriterion("trade_time <>", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeGreaterThan(Date value) {
            addCriterion("trade_time >", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("trade_time >=", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLessThan(Date value) {
            addCriterion("trade_time <", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLessThanOrEqualTo(Date value) {
            addCriterion("trade_time <=", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIn(List<Date> values) {
            addCriterion("trade_time in", values, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotIn(List<Date> values) {
            addCriterion("trade_time not in", values, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeBetween(Date value1, Date value2) {
            addCriterion("trade_time between", value1, value2, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotBetween(Date value1, Date value2) {
            addCriterion("trade_time not between", value1, value2, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNoIsNull() {
            addCriterion("shop_no is null");
            return (Criteria) this;
        }

        public Criteria andShopNoIsNotNull() {
            addCriterion("shop_no is not null");
            return (Criteria) this;
        }

        public Criteria andShopNoEqualTo(String value) {
            addCriterion("shop_no =", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotEqualTo(String value) {
            addCriterion("shop_no <>", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoGreaterThan(String value) {
            addCriterion("shop_no >", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoGreaterThanOrEqualTo(String value) {
            addCriterion("shop_no >=", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLessThan(String value) {
            addCriterion("shop_no <", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLessThanOrEqualTo(String value) {
            addCriterion("shop_no <=", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLike(String value) {
            addCriterion("shop_no like", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotLike(String value) {
            addCriterion("shop_no not like", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoIn(List<String> values) {
            addCriterion("shop_no in", values, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotIn(List<String> values) {
            addCriterion("shop_no not in", values, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoBetween(String value1, String value2) {
            addCriterion("shop_no between", value1, value2, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotBetween(String value1, String value2) {
            addCriterion("shop_no not between", value1, value2, "shopNo");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageIsNull() {
            addCriterion("buyer_message is null");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageIsNotNull() {
            addCriterion("buyer_message is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageEqualTo(String value) {
            addCriterion("buyer_message =", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotEqualTo(String value) {
            addCriterion("buyer_message <>", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageGreaterThan(String value) {
            addCriterion("buyer_message >", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_message >=", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageLessThan(String value) {
            addCriterion("buyer_message <", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageLessThanOrEqualTo(String value) {
            addCriterion("buyer_message <=", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageLike(String value) {
            addCriterion("buyer_message like", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotLike(String value) {
            addCriterion("buyer_message not like", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageIn(List<String> values) {
            addCriterion("buyer_message in", values, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotIn(List<String> values) {
            addCriterion("buyer_message not in", values, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageBetween(String value1, String value2) {
            addCriterion("buyer_message between", value1, value2, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotBetween(String value1, String value2) {
            addCriterion("buyer_message not between", value1, value2, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andCsRemarkIsNull() {
            addCriterion("cs_remark is null");
            return (Criteria) this;
        }

        public Criteria andCsRemarkIsNotNull() {
            addCriterion("cs_remark is not null");
            return (Criteria) this;
        }

        public Criteria andCsRemarkEqualTo(String value) {
            addCriterion("cs_remark =", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotEqualTo(String value) {
            addCriterion("cs_remark <>", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkGreaterThan(String value) {
            addCriterion("cs_remark >", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("cs_remark >=", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkLessThan(String value) {
            addCriterion("cs_remark <", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkLessThanOrEqualTo(String value) {
            addCriterion("cs_remark <=", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkLike(String value) {
            addCriterion("cs_remark like", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotLike(String value) {
            addCriterion("cs_remark not like", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkIn(List<String> values) {
            addCriterion("cs_remark in", values, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotIn(List<String> values) {
            addCriterion("cs_remark not in", values, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkBetween(String value1, String value2) {
            addCriterion("cs_remark between", value1, value2, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotBetween(String value1, String value2) {
            addCriterion("cs_remark not between", value1, value2, "csRemark");
            return (Criteria) this;
        }

        public Criteria andFlagNameIsNull() {
            addCriterion("flag_name is null");
            return (Criteria) this;
        }

        public Criteria andFlagNameIsNotNull() {
            addCriterion("flag_name is not null");
            return (Criteria) this;
        }

        public Criteria andFlagNameEqualTo(String value) {
            addCriterion("flag_name =", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotEqualTo(String value) {
            addCriterion("flag_name <>", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameGreaterThan(String value) {
            addCriterion("flag_name >", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameGreaterThanOrEqualTo(String value) {
            addCriterion("flag_name >=", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameLessThan(String value) {
            addCriterion("flag_name <", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameLessThanOrEqualTo(String value) {
            addCriterion("flag_name <=", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameLike(String value) {
            addCriterion("flag_name like", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotLike(String value) {
            addCriterion("flag_name not like", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameIn(List<String> values) {
            addCriterion("flag_name in", values, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotIn(List<String> values) {
            addCriterion("flag_name not in", values, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameBetween(String value1, String value2) {
            addCriterion("flag_name between", value1, value2, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotBetween(String value1, String value2) {
            addCriterion("flag_name not between", value1, value2, "flagName");
            return (Criteria) this;
        }

        public Criteria andBlockReasonIsNull() {
            addCriterion("block_reason is null");
            return (Criteria) this;
        }

        public Criteria andBlockReasonIsNotNull() {
            addCriterion("block_reason is not null");
            return (Criteria) this;
        }

        public Criteria andBlockReasonEqualTo(Integer value) {
            addCriterion("block_reason =", value, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonNotEqualTo(Integer value) {
            addCriterion("block_reason <>", value, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonGreaterThan(Integer value) {
            addCriterion("block_reason >", value, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonGreaterThanOrEqualTo(Integer value) {
            addCriterion("block_reason >=", value, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonLessThan(Integer value) {
            addCriterion("block_reason <", value, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonLessThanOrEqualTo(Integer value) {
            addCriterion("block_reason <=", value, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonIn(List<Integer> values) {
            addCriterion("block_reason in", values, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonNotIn(List<Integer> values) {
            addCriterion("block_reason not in", values, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonBetween(Integer value1, Integer value2) {
            addCriterion("block_reason between", value1, value2, "blockReason");
            return (Criteria) this;
        }

        public Criteria andBlockReasonNotBetween(Integer value1, Integer value2) {
            addCriterion("block_reason not between", value1, value2, "blockReason");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNull() {
            addCriterion("invoice_type is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNotNull() {
            addCriterion("invoice_type is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeEqualTo(Integer value) {
            addCriterion("invoice_type =", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotEqualTo(Integer value) {
            addCriterion("invoice_type <>", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThan(Integer value) {
            addCriterion("invoice_type >", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_type >=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThan(Integer value) {
            addCriterion("invoice_type <", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_type <=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIn(List<Integer> values) {
            addCriterion("invoice_type in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotIn(List<Integer> values) {
            addCriterion("invoice_type not in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeBetween(Integer value1, Integer value2) {
            addCriterion("invoice_type between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_type not between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleIsNull() {
            addCriterion("invoice_title is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleIsNotNull() {
            addCriterion("invoice_title is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleEqualTo(String value) {
            addCriterion("invoice_title =", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotEqualTo(String value) {
            addCriterion("invoice_title <>", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleGreaterThan(String value) {
            addCriterion("invoice_title >", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_title >=", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleLessThan(String value) {
            addCriterion("invoice_title <", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleLessThanOrEqualTo(String value) {
            addCriterion("invoice_title <=", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleLike(String value) {
            addCriterion("invoice_title like", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotLike(String value) {
            addCriterion("invoice_title not like", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleIn(List<String> values) {
            addCriterion("invoice_title in", values, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotIn(List<String> values) {
            addCriterion("invoice_title not in", values, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleBetween(String value1, String value2) {
            addCriterion("invoice_title between", value1, value2, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotBetween(String value1, String value2) {
            addCriterion("invoice_title not between", value1, value2, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIsNull() {
            addCriterion("invoice_content is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIsNotNull() {
            addCriterion("invoice_content is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentEqualTo(String value) {
            addCriterion("invoice_content =", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotEqualTo(String value) {
            addCriterion("invoice_content <>", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentGreaterThan(String value) {
            addCriterion("invoice_content >", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_content >=", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLessThan(String value) {
            addCriterion("invoice_content <", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLessThanOrEqualTo(String value) {
            addCriterion("invoice_content <=", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLike(String value) {
            addCriterion("invoice_content like", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotLike(String value) {
            addCriterion("invoice_content not like", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIn(List<String> values) {
            addCriterion("invoice_content in", values, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotIn(List<String> values) {
            addCriterion("invoice_content not in", values, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentBetween(String value1, String value2) {
            addCriterion("invoice_content between", value1, value2, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotBetween(String value1, String value2) {
            addCriterion("invoice_content not between", value1, value2, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIsNull() {
            addCriterion("invoice_id is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIsNotNull() {
            addCriterion("invoice_id is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdEqualTo(Integer value) {
            addCriterion("invoice_id =", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotEqualTo(Integer value) {
            addCriterion("invoice_id <>", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdGreaterThan(Integer value) {
            addCriterion("invoice_id >", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_id >=", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdLessThan(Integer value) {
            addCriterion("invoice_id <", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_id <=", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIn(List<Integer> values) {
            addCriterion("invoice_id in", values, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotIn(List<Integer> values) {
            addCriterion("invoice_id not in", values, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdBetween(Integer value1, Integer value2) {
            addCriterion("invoice_id between", value1, value2, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_id not between", value1, value2, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIsNull() {
            addCriterion("delivery_term is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIsNotNull() {
            addCriterion("delivery_term is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermEqualTo(Integer value) {
            addCriterion("delivery_term =", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotEqualTo(Integer value) {
            addCriterion("delivery_term <>", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermGreaterThan(Integer value) {
            addCriterion("delivery_term >", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_term >=", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermLessThan(Integer value) {
            addCriterion("delivery_term <", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_term <=", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIn(List<Integer> values) {
            addCriterion("delivery_term in", values, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotIn(List<Integer> values) {
            addCriterion("delivery_term not in", values, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermBetween(Integer value1, Integer value2) {
            addCriterion("delivery_term between", value1, value2, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_term not between", value1, value2, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andCodAmountIsNull() {
            addCriterion("cod_amount is null");
            return (Criteria) this;
        }

        public Criteria andCodAmountIsNotNull() {
            addCriterion("cod_amount is not null");
            return (Criteria) this;
        }

        public Criteria andCodAmountEqualTo(BigDecimal value) {
            addCriterion("cod_amount =", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountNotEqualTo(BigDecimal value) {
            addCriterion("cod_amount <>", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountGreaterThan(BigDecimal value) {
            addCriterion("cod_amount >", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cod_amount >=", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountLessThan(BigDecimal value) {
            addCriterion("cod_amount <", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cod_amount <=", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountIn(List<BigDecimal> values) {
            addCriterion("cod_amount in", values, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountNotIn(List<BigDecimal> values) {
            addCriterion("cod_amount not in", values, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cod_amount between", value1, value2, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cod_amount not between", value1, value2, "codAmount");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeIsNull() {
            addCriterion("id_card_type is null");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeIsNotNull() {
            addCriterion("id_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeEqualTo(Integer value) {
            addCriterion("id_card_type =", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeNotEqualTo(Integer value) {
            addCriterion("id_card_type <>", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeGreaterThan(Integer value) {
            addCriterion("id_card_type >", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("id_card_type >=", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeLessThan(Integer value) {
            addCriterion("id_card_type <", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeLessThanOrEqualTo(Integer value) {
            addCriterion("id_card_type <=", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeIn(List<Integer> values) {
            addCriterion("id_card_type in", values, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeNotIn(List<Integer> values) {
            addCriterion("id_card_type not in", values, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeBetween(Integer value1, Integer value2) {
            addCriterion("id_card_type between", value1, value2, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("id_card_type not between", value1, value2, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNull() {
            addCriterion("id_card is null");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNotNull() {
            addCriterion("id_card is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardEqualTo(String value) {
            addCriterion("id_card =", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotEqualTo(String value) {
            addCriterion("id_card <>", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThan(String value) {
            addCriterion("id_card >", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThanOrEqualTo(String value) {
            addCriterion("id_card >=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThan(String value) {
            addCriterion("id_card <", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThanOrEqualTo(String value) {
            addCriterion("id_card <=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLike(String value) {
            addCriterion("id_card like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotLike(String value) {
            addCriterion("id_card not like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardIn(List<String> values) {
            addCriterion("id_card in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotIn(List<String> values) {
            addCriterion("id_card not in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardBetween(String value1, String value2) {
            addCriterion("id_card between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotBetween(String value1, String value2) {
            addCriterion("id_card not between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeIsNull() {
            addCriterion("stock_check_time is null");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeIsNotNull() {
            addCriterion("stock_check_time is not null");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeEqualTo(Date value) {
            addCriterion("stock_check_time =", value, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeNotEqualTo(Date value) {
            addCriterion("stock_check_time <>", value, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeGreaterThan(Date value) {
            addCriterion("stock_check_time >", value, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("stock_check_time >=", value, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeLessThan(Date value) {
            addCriterion("stock_check_time <", value, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeLessThanOrEqualTo(Date value) {
            addCriterion("stock_check_time <=", value, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeIn(List<Date> values) {
            addCriterion("stock_check_time in", values, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeNotIn(List<Date> values) {
            addCriterion("stock_check_time not in", values, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeBetween(Date value1, Date value2) {
            addCriterion("stock_check_time between", value1, value2, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andStockCheckTimeNotBetween(Date value1, Date value2) {
            addCriterion("stock_check_time not between", value1, value2, "stockCheckTime");
            return (Criteria) this;
        }

        public Criteria andBadReasonIsNull() {
            addCriterion("bad_reason is null");
            return (Criteria) this;
        }

        public Criteria andBadReasonIsNotNull() {
            addCriterion("bad_reason is not null");
            return (Criteria) this;
        }

        public Criteria andBadReasonEqualTo(String value) {
            addCriterion("bad_reason =", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotEqualTo(String value) {
            addCriterion("bad_reason <>", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonGreaterThan(String value) {
            addCriterion("bad_reason >", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonGreaterThanOrEqualTo(String value) {
            addCriterion("bad_reason >=", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonLessThan(String value) {
            addCriterion("bad_reason <", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonLessThanOrEqualTo(String value) {
            addCriterion("bad_reason <=", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonLike(String value) {
            addCriterion("bad_reason like", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotLike(String value) {
            addCriterion("bad_reason not like", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonIn(List<String> values) {
            addCriterion("bad_reason in", values, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotIn(List<String> values) {
            addCriterion("bad_reason not in", values, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonBetween(String value1, String value2) {
            addCriterion("bad_reason between", value1, value2, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotBetween(String value1, String value2) {
            addCriterion("bad_reason not between", value1, value2, "badReason");
            return (Criteria) this;
        }

        public Criteria andDataStatusIsNull() {
            addCriterion("data_status is null");
            return (Criteria) this;
        }

        public Criteria andDataStatusIsNotNull() {
            addCriterion("data_status is not null");
            return (Criteria) this;
        }

        public Criteria andDataStatusEqualTo(String value) {
            addCriterion("data_status =", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusNotEqualTo(String value) {
            addCriterion("data_status <>", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusGreaterThan(String value) {
            addCriterion("data_status >", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusGreaterThanOrEqualTo(String value) {
            addCriterion("data_status >=", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusLessThan(String value) {
            addCriterion("data_status <", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusLessThanOrEqualTo(String value) {
            addCriterion("data_status <=", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusLike(String value) {
            addCriterion("data_status like", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusNotLike(String value) {
            addCriterion("data_status not like", value, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusIn(List<String> values) {
            addCriterion("data_status in", values, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusNotIn(List<String> values) {
            addCriterion("data_status not in", values, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusBetween(String value1, String value2) {
            addCriterion("data_status between", value1, value2, "dataStatus");
            return (Criteria) this;
        }

        public Criteria andDataStatusNotBetween(String value1, String value2) {
            addCriterion("data_status not between", value1, value2, "dataStatus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}